Need Help for Excel "If Function"

Hi Guys

I want to create a IF function in excel that will do this

1 m2 = SGD 9

Minimum = SGD 60

So if i key in any number below 7 m2, it will show SGD 60, but above 7m2, it will auto calculate based on m2 x Amount which is SGD 9

How to do?

IF(m2<7, "SGD 60", m2*amt)

Thank you so much Mospeada

One more question

if SGD 22 Per 4 M2

So if i key in between 1-4,. it will show SGD 22

But if i key in 5-8, it will show SGD 44

If i keep 9-12, it will show SDG 66

issit possible to do this function?

One more question

if SGD 22 Per 4 M2

So if i key in between 1-4,. it will show SGD 22

But if i key in 5-8, it will show SGD 44

If i keep 9-12, it will show SDG 66

issit possible to do this function?

then u got to do multiple liao...IF inside the IF

i think i can only help u better if you put those data in rows and column, since you want to know how to structure the equation

One more question

if SGD 22 Per 4 M2

So if i key in between 1-4,. it will show SGD 22

But if i key in 5-8, it will show SGD 44

If i keep 9-12, it will show SDG 66

issit possible to do this function?

Not sure if this can work

=(INT(m2/4)+1)*22

Mospeada like this?

Not sure if this can work

=(INT(m2/4)+1)*22

Thanks so Much Eagle

It works :D